{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 基本面数据\n",
    "\n",
    "- 来自 http://tushare.org/fundamental.html 的基本面数据。\n",
    "\n",
    "基本面类数据提供所有股票的基本面情况，包括股本情况、业绩预告和业绩报告等。主要包括以下类别：\n",
    "\n",
    "    沪深股票列表\n",
    "    业绩预告\n",
    "    业绩报告（主表）\n",
    "    盈利能力数据\n",
    "    营运能力数据\n",
    "    成长能力数据\n",
    "    偿债能力数据\n",
    "    现金流量数据\n",
    "\n",
    "本模块数据全部来自sina财经，由于财务数据项目比较多，所以拆分成了几个表，使用时可以通过股票代码合并在一起，也可以独立使用。数据在获取时，需要一页一页的抓取，所以需要一点等待时间，最后会合并成一个大表。\n",
    "股票列表\n",
    "\n",
    "获取沪深上市公司基本情况。属性包括：\n",
    "```\n",
    "code,代码\n",
    "name,名称\n",
    "industry,所属行业\n",
    "area,地区\n",
    "pe,市盈率\n",
    "outstanding,流通股本(亿)\n",
    "totals,总股本(亿)\n",
    "totalAssets,总资产(万)\n",
    "liquidAssets,流动资产\n",
    "fixedAssets,固定资产\n",
    "reserved,公积金\n",
    "reservedPerShare,每股公积金\n",
    "esp,每股收益\n",
    "bvps,每股净资\n",
    "pb,市净率\n",
    "timeToMarket,上市日期\n",
    "undp,未分利润\n",
    "perundp, 每股未分配\n",
    "rev,收入同比(%)\n",
    "profit,利润同比(%)\n",
    "gpr,毛利率(%)\n",
    "npr,净利润率(%)\n",
    "holders,股东人数\n",
    "```\n",
    "\n",
    "调用方法：\n",
    "```\n",
    "import tushare as ts\n",
    "ts.get_stock_basics()\n",
    "```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts\n",
    "\n",
    "sb = ts.get_stock_basics()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>industry</th>\n",
       "      <th>area</th>\n",
       "      <th>pe</th>\n",
       "      <th>outstanding</th>\n",
       "      <th>totals</th>\n",
       "      <th>totalAssets</th>\n",
       "      <th>liquidAssets</th>\n",
       "      <th>fixedAssets</th>\n",
       "      <th>reserved</th>\n",
       "      <th>...</th>\n",
       "      <th>bvps</th>\n",
       "      <th>pb</th>\n",
       "      <th>timeToMarket</th>\n",
       "      <th>undp</th>\n",
       "      <th>perundp</th>\n",
       "      <th>rev</th>\n",
       "      <th>profit</th>\n",
       "      <th>gpr</th>\n",
       "      <th>npr</th>\n",
       "      <th>holders</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>code</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>300028</th>\n",
       "      <td>*金亚</td>\n",
       "      <td>通信设备</td>\n",
       "      <td>四川</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3.44</td>\n",
       "      <td>3.44</td>\n",
       "      <td>28822.96</td>\n",
       "      <td>8798.60</td>\n",
       "      <td>1260.96</td>\n",
       "      <td>36319.64</td>\n",
       "      <td>...</td>\n",
       "      <td>0.49</td>\n",
       "      <td>1.91</td>\n",
       "      <td>20091030</td>\n",
       "      <td>-53770.92</td>\n",
       "      <td>-1.56</td>\n",
       "      <td>689.74</td>\n",
       "      <td>63.14</td>\n",
       "      <td>-4.99</td>\n",
       "      <td>-42.90</td>\n",
       "      <td>43895.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000509</th>\n",
       "      <td>华塑控股</td>\n",
       "      <td>其他建材</td>\n",
       "      <td>四川</td>\n",
       "      <td>0.00</td>\n",
       "      <td>8.25</td>\n",
       "      <td>8.25</td>\n",
       "      <td>24894.26</td>\n",
       "      <td>18130.70</td>\n",
       "      <td>1169.06</td>\n",
       "      <td>21226.06</td>\n",
       "      <td>...</td>\n",
       "      <td>0.05</td>\n",
       "      <td>51.74</td>\n",
       "      <td>19930507</td>\n",
       "      <td>-102324.15</td>\n",
       "      <td>-1.24</td>\n",
       "      <td>585.13</td>\n",
       "      <td>-0.01</td>\n",
       "      <td>0.55</td>\n",
       "      <td>-0.78</td>\n",
       "      <td>63186.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000680</th>\n",
       "      <td>山推股份</td>\n",
       "      <td>工程机械</td>\n",
       "      <td>山东</td>\n",
       "      <td>29.73</td>\n",
       "      <td>10.57</td>\n",
       "      <td>12.41</td>\n",
       "      <td>1014333.38</td>\n",
       "      <td>655271.00</td>\n",
       "      <td>170036.41</td>\n",
       "      <td>120013.10</td>\n",
       "      <td>...</td>\n",
       "      <td>2.70</td>\n",
       "      <td>1.49</td>\n",
       "      <td>19970122</td>\n",
       "      <td>53637.21</td>\n",
       "      <td>0.43</td>\n",
       "      <td>30.83</td>\n",
       "      <td>149.71</td>\n",
       "      <td>14.03</td>\n",
       "      <td>1.99</td>\n",
       "      <td>121102.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300058</th>\n",
       "      <td>蓝色光标</td>\n",
       "      <td>广告包装</td>\n",
       "      <td>北京</td>\n",
       "      <td>20.98</td>\n",
       "      <td>16.62</td>\n",
       "      <td>21.82</td>\n",
       "      <td>1712029.75</td>\n",
       "      <td>898685.81</td>\n",
       "      <td>11862.67</td>\n",
       "      <td>266160.66</td>\n",
       "      <td>...</td>\n",
       "      <td>2.80</td>\n",
       "      <td>2.11</td>\n",
       "      <td>20100226</td>\n",
       "      <td>195004.25</td>\n",
       "      <td>0.89</td>\n",
       "      <td>70.62</td>\n",
       "      <td>89.69</td>\n",
       "      <td>13.01</td>\n",
       "      <td>3.05</td>\n",
       "      <td>80183.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300129</th>\n",
       "      <td>泰胜风能</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>上海</td>\n",
       "      <td>48.68</td>\n",
       "      <td>4.91</td>\n",
       "      <td>7.19</td>\n",
       "      <td>318765.88</td>\n",
       "      <td>209734.02</td>\n",
       "      <td>60982.78</td>\n",
       "      <td>70538.61</td>\n",
       "      <td>...</td>\n",
       "      <td>3.15</td>\n",
       "      <td>1.21</td>\n",
       "      <td>20101019</td>\n",
       "      <td>80128.02</td>\n",
       "      <td>1.11</td>\n",
       "      <td>35.41</td>\n",
       "      <td>-65.04</td>\n",
       "      <td>24.50</td>\n",
       "      <td>6.08</td>\n",
       "      <td>45010.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002447</th>\n",
       "      <td>晨鑫科技</td>\n",
       "      <td>互联网</td>\n",
       "      <td>辽宁</td>\n",
       "      <td>18.89</td>\n",
       "      <td>11.50</td>\n",
       "      <td>14.27</td>\n",
       "      <td>278472.50</td>\n",
       "      <td>77991.53</td>\n",
       "      <td>39287.96</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>1.51</td>\n",
       "      <td>2.53</td>\n",
       "      <td>20100713</td>\n",
       "      <td>69922.93</td>\n",
       "      <td>0.49</td>\n",
       "      <td>191.73</td>\n",
       "      <td>559.98</td>\n",
       "      <td>73.05</td>\n",
       "      <td>46.88</td>\n",
       "      <td>73862.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000955</th>\n",
       "      <td>欣龙控股</td>\n",
       "      <td>纺织</td>\n",
       "      <td>海南</td>\n",
       "      <td>0.00</td>\n",
       "      <td>5.38</td>\n",
       "      <td>5.38</td>\n",
       "      <td>130058.56</td>\n",
       "      <td>66284.50</td>\n",
       "      <td>44417.80</td>\n",
       "      <td>49573.46</td>\n",
       "      <td>...</td>\n",
       "      <td>1.33</td>\n",
       "      <td>4.03</td>\n",
       "      <td>19991209</td>\n",
       "      <td>-31975.74</td>\n",
       "      <td>-0.59</td>\n",
       "      <td>18.88</td>\n",
       "      <td>-595.87</td>\n",
       "      <td>12.10</td>\n",
       "      <td>-5.93</td>\n",
       "      <td>34521.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002786</th>\n",
       "      <td>银宝山新</td>\n",
       "      <td>专用机械</td>\n",
       "      <td>深圳</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.37</td>\n",
       "      <td>3.81</td>\n",
       "      <td>382388.88</td>\n",
       "      <td>254915.72</td>\n",
       "      <td>89801.25</td>\n",
       "      <td>17355.93</td>\n",
       "      <td>...</td>\n",
       "      <td>2.85</td>\n",
       "      <td>2.41</td>\n",
       "      <td>20151223</td>\n",
       "      <td>47619.00</td>\n",
       "      <td>1.25</td>\n",
       "      <td>7.81</td>\n",
       "      <td>-306.02</td>\n",
       "      <td>14.04</td>\n",
       "      <td>-2.61</td>\n",
       "      <td>35296.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300032</th>\n",
       "      <td>金龙机电</td>\n",
       "      <td>元器件</td>\n",
       "      <td>浙江</td>\n",
       "      <td>0.00</td>\n",
       "      <td>7.89</td>\n",
       "      <td>8.03</td>\n",
       "      <td>687549.38</td>\n",
       "      <td>399175.13</td>\n",
       "      <td>126680.40</td>\n",
       "      <td>319012.75</td>\n",
       "      <td>...</td>\n",
       "      <td>5.00</td>\n",
       "      <td>1.03</td>\n",
       "      <td>20091225</td>\n",
       "      <td>-11428.19</td>\n",
       "      <td>-0.14</td>\n",
       "      <td>29.32</td>\n",
       "      <td>-227.05</td>\n",
       "      <td>15.12</td>\n",
       "      <td>-2.67</td>\n",
       "      <td>26221.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600812</th>\n",
       "      <td>华北制药</td>\n",
       "      <td>化学制药</td>\n",
       "      <td>河北</td>\n",
       "      <td>84.34</td>\n",
       "      <td>16.31</td>\n",
       "      <td>16.31</td>\n",
       "      <td>1716590.25</td>\n",
       "      <td>685183.38</td>\n",
       "      <td>771604.75</td>\n",
       "      <td>348135.28</td>\n",
       "      <td>...</td>\n",
       "      <td>3.27</td>\n",
       "      <td>1.67</td>\n",
       "      <td>19940114</td>\n",
       "      <td>-105.19</td>\n",
       "      <td>0.00</td>\n",
       "      <td>13.94</td>\n",
       "      <td>96.02</td>\n",
       "      <td>35.74</td>\n",
       "      <td>1.07</td>\n",
       "      <td>82855.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000613</th>\n",
       "      <td>大东海A</td>\n",
       "      <td>旅游服务</td>\n",
       "      <td>海南</td>\n",
       "      <td>404.08</td>\n",
       "      <td>2.66</td>\n",
       "      <td>3.64</td>\n",
       "      <td>8896.94</td>\n",
       "      <td>1619.50</td>\n",
       "      <td>3843.58</td>\n",
       "      <td>5414.27</td>\n",
       "      <td>...</td>\n",
       "      <td>0.22</td>\n",
       "      <td>40.32</td>\n",
       "      <td>19970128</td>\n",
       "      <td>-33913.40</td>\n",
       "      <td>-0.93</td>\n",
       "      <td>5.39</td>\n",
       "      <td>-18.13</td>\n",
       "      <td>68.90</td>\n",
       "      <td>19.95</td>\n",
       "      <td>40000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600712</th>\n",
       "      <td>南宁百货</td>\n",
       "      <td>百货</td>\n",
       "      <td>广西</td>\n",
       "      <td>0.00</td>\n",
       "      <td>5.38</td>\n",
       "      <td>5.45</td>\n",
       "      <td>223470.66</td>\n",
       "      <td>74036.81</td>\n",
       "      <td>110228.90</td>\n",
       "      <td>36985.75</td>\n",
       "      <td>...</td>\n",
       "      <td>1.95</td>\n",
       "      <td>2.41</td>\n",
       "      <td>19960626</td>\n",
       "      <td>9523.53</td>\n",
       "      <td>0.17</td>\n",
       "      <td>10.20</td>\n",
       "      <td>31.67</td>\n",
       "      <td>15.51</td>\n",
       "      <td>-0.02</td>\n",
       "      <td>24310.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000498</th>\n",
       "      <td>山东路桥</td>\n",
       "      <td>建筑施工</td>\n",
       "      <td>山东</td>\n",
       "      <td>42.80</td>\n",
       "      <td>4.41</td>\n",
       "      <td>11.20</td>\n",
       "      <td>1818272.63</td>\n",
       "      <td>1446253.50</td>\n",
       "      <td>62741.83</td>\n",
       "      <td>-55661.53</td>\n",
       "      <td>...</td>\n",
       "      <td>3.61</td>\n",
       "      <td>1.37</td>\n",
       "      <td>19970609</td>\n",
       "      <td>254251.02</td>\n",
       "      <td>2.27</td>\n",
       "      <td>52.18</td>\n",
       "      <td>20.25</td>\n",
       "      <td>8.35</td>\n",
       "      <td>1.63</td>\n",
       "      <td>51067.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000735</th>\n",
       "      <td>罗 牛 山</td>\n",
       "      <td>农业综合</td>\n",
       "      <td>海南</td>\n",
       "      <td>11.04</td>\n",
       "      <td>10.60</td>\n",
       "      <td>11.52</td>\n",
       "      <td>648092.25</td>\n",
       "      <td>184335.61</td>\n",
       "      <td>194501.98</td>\n",
       "      <td>158896.80</td>\n",
       "      <td>...</td>\n",
       "      <td>3.36</td>\n",
       "      <td>3.79</td>\n",
       "      <td>19970611</td>\n",
       "      <td>102907.93</td>\n",
       "      <td>0.89</td>\n",
       "      <td>-63.64</td>\n",
       "      <td>284.81</td>\n",
       "      <td>16.97</td>\n",
       "      <td>167.48</td>\n",
       "      <td>178400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300443</th>\n",
       "      <td>金雷风电</td>\n",
       "      <td>专用机械</td>\n",
       "      <td>山东</td>\n",
       "      <td>49.94</td>\n",
       "      <td>1.59</td>\n",
       "      <td>2.38</td>\n",
       "      <td>171590.59</td>\n",
       "      <td>106978.13</td>\n",
       "      <td>43072.73</td>\n",
       "      <td>68372.13</td>\n",
       "      <td>...</td>\n",
       "      <td>6.87</td>\n",
       "      <td>1.63</td>\n",
       "      <td>20150422</td>\n",
       "      <td>63543.19</td>\n",
       "      <td>2.67</td>\n",
       "      <td>-41.59</td>\n",
       "      <td>-73.77</td>\n",
       "      <td>26.27</td>\n",
       "      <td>13.32</td>\n",
       "      <td>17864.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600303</th>\n",
       "      <td>曙光股份</td>\n",
       "      <td>汽车整车</td>\n",
       "      <td>辽宁</td>\n",
       "      <td>69.31</td>\n",
       "      <td>6.20</td>\n",
       "      <td>6.76</td>\n",
       "      <td>757613.50</td>\n",
       "      <td>368062.97</td>\n",
       "      <td>250697.25</td>\n",
       "      <td>111036.77</td>\n",
       "      <td>...</td>\n",
       "      <td>4.61</td>\n",
       "      <td>1.24</td>\n",
       "      <td>20001226</td>\n",
       "      <td>105605.81</td>\n",
       "      <td>1.56</td>\n",
       "      <td>-3.49</td>\n",
       "      <td>-96.89</td>\n",
       "      <td>18.62</td>\n",
       "      <td>1.63</td>\n",
       "      <td>75427.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002759</th>\n",
       "      <td>天际股份</td>\n",
       "      <td>家用电器</td>\n",
       "      <td>广东</td>\n",
       "      <td>119.56</td>\n",
       "      <td>1.26</td>\n",
       "      <td>4.52</td>\n",
       "      <td>377837.97</td>\n",
       "      <td>82102.21</td>\n",
       "      <td>56931.60</td>\n",
       "      <td>261366.27</td>\n",
       "      <td>...</td>\n",
       "      <td>7.42</td>\n",
       "      <td>1.23</td>\n",
       "      <td>20150528</td>\n",
       "      <td>25523.82</td>\n",
       "      <td>0.56</td>\n",
       "      <td>-31.15</td>\n",
       "      <td>-89.40</td>\n",
       "      <td>28.07</td>\n",
       "      <td>4.91</td>\n",
       "      <td>18577.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300096</th>\n",
       "      <td>易联众</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>福建</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3.77</td>\n",
       "      <td>4.30</td>\n",
       "      <td>186299.81</td>\n",
       "      <td>126820.07</td>\n",
       "      <td>8067.67</td>\n",
       "      <td>3240.18</td>\n",
       "      <td>...</td>\n",
       "      <td>1.64</td>\n",
       "      <td>6.47</td>\n",
       "      <td>20100728</td>\n",
       "      <td>21774.78</td>\n",
       "      <td>0.51</td>\n",
       "      <td>59.23</td>\n",
       "      <td>17.87</td>\n",
       "      <td>56.91</td>\n",
       "      <td>-22.66</td>\n",
       "      <td>22871.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300238</th>\n",
       "      <td>冠昊生物</td>\n",
       "      <td>医疗保健</td>\n",
       "      <td>广东</td>\n",
       "      <td>130.09</td>\n",
       "      <td>2.46</td>\n",
       "      <td>2.65</td>\n",
       "      <td>166138.77</td>\n",
       "      <td>40367.30</td>\n",
       "      <td>19332.30</td>\n",
       "      <td>58982.98</td>\n",
       "      <td>...</td>\n",
       "      <td>4.39</td>\n",
       "      <td>3.35</td>\n",
       "      <td>20110706</td>\n",
       "      <td>28590.51</td>\n",
       "      <td>1.08</td>\n",
       "      <td>-8.92</td>\n",
       "      <td>-9.45</td>\n",
       "      <td>71.04</td>\n",
       "      <td>9.46</td>\n",
       "      <td>20905.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601619</th>\n",
       "      <td>嘉泽新能</td>\n",
       "      <td>新型电力</td>\n",
       "      <td>宁夏</td>\n",
       "      <td>74.02</td>\n",
       "      <td>1.94</td>\n",
       "      <td>19.33</td>\n",
       "      <td>891525.38</td>\n",
       "      <td>150262.70</td>\n",
       "      <td>614176.25</td>\n",
       "      <td>19287.90</td>\n",
       "      <td>...</td>\n",
       "      <td>1.28</td>\n",
       "      <td>5.90</td>\n",
       "      <td>20170720</td>\n",
       "      <td>33416.89</td>\n",
       "      <td>0.17</td>\n",
       "      <td>27.63</td>\n",
       "      <td>71.02</td>\n",
       "      <td>55.15</td>\n",
       "      <td>21.69</td>\n",
       "      <td>70322.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002072</th>\n",
       "      <td>凯瑞德</td>\n",
       "      <td>互联网</td>\n",
       "      <td>山东</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.76</td>\n",
       "      <td>1.76</td>\n",
       "      <td>67810.21</td>\n",
       "      <td>46591.28</td>\n",
       "      <td>289.06</td>\n",
       "      <td>19168.22</td>\n",
       "      <td>...</td>\n",
       "      <td>0.32</td>\n",
       "      <td>26.08</td>\n",
       "      <td>20061018</td>\n",
       "      <td>-35039.10</td>\n",
       "      <td>-1.99</td>\n",
       "      <td>90.53</td>\n",
       "      <td>-85.18</td>\n",
       "      <td>10.51</td>\n",
       "      <td>-12.29</td>\n",
       "      <td>7603.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300635</th>\n",
       "      <td>达安股份</td>\n",
       "      <td>建筑施工</td>\n",
       "      <td>广东</td>\n",
       "      <td>45.58</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1.36</td>\n",
       "      <td>88269.88</td>\n",
       "      <td>69621.18</td>\n",
       "      <td>3760.75</td>\n",
       "      <td>22048.47</td>\n",
       "      <td>...</td>\n",
       "      <td>4.49</td>\n",
       "      <td>3.74</td>\n",
       "      <td>20170331</td>\n",
       "      <td>22471.31</td>\n",
       "      <td>1.66</td>\n",
       "      <td>18.43</td>\n",
       "      <td>9.39</td>\n",
       "      <td>33.26</td>\n",
       "      <td>11.99</td>\n",
       "      <td>12309.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002899</th>\n",
       "      <td>英派斯</td>\n",
       "      <td>文教休闲</td>\n",
       "      <td>山东</td>\n",
       "      <td>116.00</td>\n",
       "      <td>0.30</td>\n",
       "      <td>1.20</td>\n",
       "      <td>120439.52</td>\n",
       "      <td>90348.06</td>\n",
       "      <td>18197.43</td>\n",
       "      <td>62523.36</td>\n",
       "      <td>...</td>\n",
       "      <td>7.98</td>\n",
       "      <td>2.90</td>\n",
       "      <td>20170915</td>\n",
       "      <td>18716.98</td>\n",
       "      <td>1.56</td>\n",
       "      <td>11.45</td>\n",
       "      <td>-61.27</td>\n",
       "      <td>27.74</td>\n",
       "      <td>3.44</td>\n",
       "      <td>18153.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603843</th>\n",
       "      <td>正平股份</td>\n",
       "      <td>建筑施工</td>\n",
       "      <td>青海</td>\n",
       "      <td>47.01</td>\n",
       "      <td>1.93</td>\n",
       "      <td>4.00</td>\n",
       "      <td>473199.75</td>\n",
       "      <td>352058.41</td>\n",
       "      <td>45174.01</td>\n",
       "      <td>37026.40</td>\n",
       "      <td>...</td>\n",
       "      <td>3.27</td>\n",
       "      <td>2.92</td>\n",
       "      <td>20160905</td>\n",
       "      <td>43340.73</td>\n",
       "      <td>1.08</td>\n",
       "      <td>248.13</td>\n",
       "      <td>245.44</td>\n",
       "      <td>7.77</td>\n",
       "      <td>3.39</td>\n",
       "      <td>25696.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600876</th>\n",
       "      <td>洛阳玻璃</td>\n",
       "      <td>玻璃</td>\n",
       "      <td>河南</td>\n",
       "      <td>551.66</td>\n",
       "      <td>2.62</td>\n",
       "      <td>5.60</td>\n",
       "      <td>301194.34</td>\n",
       "      <td>101826.80</td>\n",
       "      <td>147461.95</td>\n",
       "      <td>129728.22</td>\n",
       "      <td>...</td>\n",
       "      <td>1.01</td>\n",
       "      <td>15.86</td>\n",
       "      <td>19951031</td>\n",
       "      <td>-134282.52</td>\n",
       "      <td>-2.40</td>\n",
       "      <td>-10.95</td>\n",
       "      <td>-66.96</td>\n",
       "      <td>28.21</td>\n",
       "      <td>1.68</td>\n",
       "      <td>58178.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000760</th>\n",
       "      <td>斯太尔</td>\n",
       "      <td>汽车配件</td>\n",
       "      <td>湖北</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6.54</td>\n",
       "      <td>7.72</td>\n",
       "      <td>237887.88</td>\n",
       "      <td>81028.38</td>\n",
       "      <td>30768.28</td>\n",
       "      <td>142629.50</td>\n",
       "      <td>...</td>\n",
       "      <td>2.32</td>\n",
       "      <td>2.42</td>\n",
       "      <td>19970627</td>\n",
       "      <td>-40307.01</td>\n",
       "      <td>-0.52</td>\n",
       "      <td>93.24</td>\n",
       "      <td>29.63</td>\n",
       "      <td>19.02</td>\n",
       "      <td>-43.31</td>\n",
       "      <td>45460.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300547</th>\n",
       "      <td>川环科技</td>\n",
       "      <td>橡胶</td>\n",
       "      <td>四川</td>\n",
       "      <td>27.13</td>\n",
       "      <td>0.63</td>\n",
       "      <td>1.23</td>\n",
       "      <td>99290.40</td>\n",
       "      <td>80726.84</td>\n",
       "      <td>14631.29</td>\n",
       "      <td>38303.71</td>\n",
       "      <td>...</td>\n",
       "      <td>5.95</td>\n",
       "      <td>4.04</td>\n",
       "      <td>20160930</td>\n",
       "      <td>31618.75</td>\n",
       "      <td>2.56</td>\n",
       "      <td>19.44</td>\n",
       "      <td>23.13</td>\n",
       "      <td>36.38</td>\n",
       "      <td>17.79</td>\n",
       "      <td>14513.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300134</th>\n",
       "      <td>大富科技</td>\n",
       "      <td>通信设备</td>\n",
       "      <td>深圳</td>\n",
       "      <td>75.02</td>\n",
       "      <td>7.12</td>\n",
       "      <td>7.67</td>\n",
       "      <td>723251.50</td>\n",
       "      <td>431399.44</td>\n",
       "      <td>145129.63</td>\n",
       "      <td>484651.84</td>\n",
       "      <td>...</td>\n",
       "      <td>6.98</td>\n",
       "      <td>1.78</td>\n",
       "      <td>20101026</td>\n",
       "      <td>-36342.10</td>\n",
       "      <td>-0.47</td>\n",
       "      <td>-4.02</td>\n",
       "      <td>243.60</td>\n",
       "      <td>20.04</td>\n",
       "      <td>7.01</td>\n",
       "      <td>58325.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603105</th>\n",
       "      <td>芯能科技</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>浙江</td>\n",
       "      <td>251.20</td>\n",
       "      <td>0.88</td>\n",
       "      <td>5.00</td>\n",
       "      <td>219210.59</td>\n",
       "      <td>83854.71</td>\n",
       "      <td>123671.57</td>\n",
       "      <td>42923.34</td>\n",
       "      <td>...</td>\n",
       "      <td>2.50</td>\n",
       "      <td>8.74</td>\n",
       "      <td>20180709</td>\n",
       "      <td>16217.49</td>\n",
       "      <td>0.32</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>38.38</td>\n",
       "      <td>12.35</td>\n",
       "      <td>84136.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300746</th>\n",
       "      <td>汉嘉设计</td>\n",
       "      <td>建筑施工</td>\n",
       "      <td>浙江</td>\n",
       "      <td>175.50</td>\n",
       "      <td>0.53</td>\n",
       "      <td>2.10</td>\n",
       "      <td>84655.75</td>\n",
       "      <td>62115.23</td>\n",
       "      <td>15889.55</td>\n",
       "      <td>10680.12</td>\n",
       "      <td>...</td>\n",
       "      <td>3.87</td>\n",
       "      <td>10.19</td>\n",
       "      <td>20180525</td>\n",
       "      <td>29412.24</td>\n",
       "      <td>1.40</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>18.70</td>\n",
       "      <td>6.51</td>\n",
       "      <td>100201.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300469</th>\n",
       "      <td>信息发展</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>上海</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.97</td>\n",
       "      <td>1.22</td>\n",
       "      <td>120729.17</td>\n",
       "      <td>84026.68</td>\n",
       "      <td>1839.18</td>\n",
       "      <td>22466.65</td>\n",
       "      <td>...</td>\n",
       "      <td>3.31</td>\n",
       "      <td>7.90</td>\n",
       "      <td>20150611</td>\n",
       "      <td>15062.50</td>\n",
       "      <td>1.23</td>\n",
       "      <td>-9.21</td>\n",
       "      <td>12.76</td>\n",
       "      <td>45.10</td>\n",
       "      <td>-41.62</td>\n",
       "      <td>15609.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002896</th>\n",
       "      <td>中大力德</td>\n",
       "      <td>机械基件</td>\n",
       "      <td>浙江</td>\n",
       "      <td>70.25</td>\n",
       "      <td>0.20</td>\n",
       "      <td>0.80</td>\n",
       "      <td>79958.13</td>\n",
       "      <td>46085.62</td>\n",
       "      <td>24906.48</td>\n",
       "      <td>32320.94</td>\n",
       "      <td>...</td>\n",
       "      <td>6.81</td>\n",
       "      <td>6.54</td>\n",
       "      <td>20170829</td>\n",
       "      <td>12825.95</td>\n",
       "      <td>1.60</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>32.17</td>\n",
       "      <td>11.40</td>\n",
       "      <td>11789.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002375</th>\n",
       "      <td>亚厦股份</td>\n",
       "      <td>装修装饰</td>\n",
       "      <td>浙江</td>\n",
       "      <td>24.70</td>\n",
       "      <td>12.52</td>\n",
       "      <td>13.40</td>\n",
       "      <td>1875978.63</td>\n",
       "      <td>1593443.50</td>\n",
       "      <td>72511.11</td>\n",
       "      <td>183730.72</td>\n",
       "      <td>...</td>\n",
       "      <td>5.65</td>\n",
       "      <td>1.08</td>\n",
       "      <td>20100323</td>\n",
       "      <td>405948.38</td>\n",
       "      <td>3.03</td>\n",
       "      <td>16.53</td>\n",
       "      <td>11.70</td>\n",
       "      <td>13.61</td>\n",
       "      <td>4.43</td>\n",
       "      <td>40718.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002580</th>\n",
       "      <td>圣阳股份</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>山东</td>\n",
       "      <td>148.50</td>\n",
       "      <td>2.98</td>\n",
       "      <td>3.54</td>\n",
       "      <td>199927.50</td>\n",
       "      <td>139065.56</td>\n",
       "      <td>42368.53</td>\n",
       "      <td>53754.13</td>\n",
       "      <td>...</td>\n",
       "      <td>3.31</td>\n",
       "      <td>1.98</td>\n",
       "      <td>20110506</td>\n",
       "      <td>27261.44</td>\n",
       "      <td>0.77</td>\n",
       "      <td>13.38</td>\n",
       "      <td>-38.89</td>\n",
       "      <td>14.82</td>\n",
       "      <td>1.07</td>\n",
       "      <td>36062.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600734</th>\n",
       "      <td>实达集团</td>\n",
       "      <td>电脑设备</td>\n",
       "      <td>福建</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3.55</td>\n",
       "      <td>6.24</td>\n",
       "      <td>840366.13</td>\n",
       "      <td>590714.06</td>\n",
       "      <td>21819.70</td>\n",
       "      <td>209117.17</td>\n",
       "      <td>...</td>\n",
       "      <td>4.56</td>\n",
       "      <td>1.75</td>\n",
       "      <td>19960808</td>\n",
       "      <td>11150.55</td>\n",
       "      <td>0.18</td>\n",
       "      <td>-13.89</td>\n",
       "      <td>-1950.34</td>\n",
       "      <td>7.03</td>\n",
       "      <td>-2.70</td>\n",
       "      <td>40863.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002778</th>\n",
       "      <td>高科石化</td>\n",
       "      <td>石油加工</td>\n",
       "      <td>江苏</td>\n",
       "      <td>78.92</td>\n",
       "      <td>0.56</td>\n",
       "      <td>0.89</td>\n",
       "      <td>76581.24</td>\n",
       "      <td>51419.80</td>\n",
       "      <td>7615.63</td>\n",
       "      <td>21435.85</td>\n",
       "      <td>...</td>\n",
       "      <td>7.01</td>\n",
       "      <td>3.14</td>\n",
       "      <td>20160106</td>\n",
       "      <td>28851.31</td>\n",
       "      <td>3.24</td>\n",
       "      <td>-3.01</td>\n",
       "      <td>-22.90</td>\n",
       "      <td>13.62</td>\n",
       "      <td>4.74</td>\n",
       "      <td>12070.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002806</th>\n",
       "      <td>华锋股份</td>\n",
       "      <td>元器件</td>\n",
       "      <td>广东</td>\n",
       "      <td>249.71</td>\n",
       "      <td>0.56</td>\n",
       "      <td>1.37</td>\n",
       "      <td>67823.78</td>\n",
       "      <td>35466.23</td>\n",
       "      <td>21915.98</td>\n",
       "      <td>3962.88</td>\n",
       "      <td>...</td>\n",
       "      <td>2.85</td>\n",
       "      <td>9.64</td>\n",
       "      <td>20160726</td>\n",
       "      <td>19428.03</td>\n",
       "      <td>1.42</td>\n",
       "      <td>14.89</td>\n",
       "      <td>8.52</td>\n",
       "      <td>20.02</td>\n",
       "      <td>3.57</td>\n",
       "      <td>16400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300551</th>\n",
       "      <td>古鳌科技</td>\n",
       "      <td>专用机械</td>\n",
       "      <td>上海</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.65</td>\n",
       "      <td>1.10</td>\n",
       "      <td>65781.31</td>\n",
       "      <td>55414.13</td>\n",
       "      <td>8572.61</td>\n",
       "      <td>22942.30</td>\n",
       "      <td>...</td>\n",
       "      <td>4.65</td>\n",
       "      <td>3.10</td>\n",
       "      <td>20161018</td>\n",
       "      <td>18743.60</td>\n",
       "      <td>1.70</td>\n",
       "      <td>38.04</td>\n",
       "      <td>13.87</td>\n",
       "      <td>41.53</td>\n",
       "      <td>-61.74</td>\n",
       "      <td>12384.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600448</th>\n",
       "      <td>华纺股份</td>\n",
       "      <td>纺织</td>\n",
       "      <td>山东</td>\n",
       "      <td>329.86</td>\n",
       "      <td>4.22</td>\n",
       "      <td>5.25</td>\n",
       "      <td>348429.72</td>\n",
       "      <td>207782.20</td>\n",
       "      <td>97555.05</td>\n",
       "      <td>114670.90</td>\n",
       "      <td>...</td>\n",
       "      <td>2.76</td>\n",
       "      <td>1.63</td>\n",
       "      <td>20010903</td>\n",
       "      <td>-22770.80</td>\n",
       "      <td>-0.43</td>\n",
       "      <td>27.87</td>\n",
       "      <td>-19.26</td>\n",
       "      <td>5.12</td>\n",
       "      <td>0.24</td>\n",
       "      <td>29660.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002857</th>\n",
       "      <td>三晖电气</td>\n",
       "      <td>电器仪表</td>\n",
       "      <td>河南</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.49</td>\n",
       "      <td>1.28</td>\n",
       "      <td>54155.85</td>\n",
       "      <td>49890.67</td>\n",
       "      <td>1136.95</td>\n",
       "      <td>16406.72</td>\n",
       "      <td>...</td>\n",
       "      <td>3.31</td>\n",
       "      <td>4.27</td>\n",
       "      <td>20170323</td>\n",
       "      <td>15747.24</td>\n",
       "      <td>1.23</td>\n",
       "      <td>-24.90</td>\n",
       "      <td>54.82</td>\n",
       "      <td>36.68</td>\n",
       "      <td>-12.03</td>\n",
       "      <td>7366.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300491</th>\n",
       "      <td>通合科技</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>河北</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.51</td>\n",
       "      <td>1.45</td>\n",
       "      <td>56704.98</td>\n",
       "      <td>37041.20</td>\n",
       "      <td>16516.35</td>\n",
       "      <td>18042.42</td>\n",
       "      <td>...</td>\n",
       "      <td>2.96</td>\n",
       "      <td>6.16</td>\n",
       "      <td>20151231</td>\n",
       "      <td>10821.80</td>\n",
       "      <td>0.75</td>\n",
       "      <td>-10.47</td>\n",
       "      <td>16.74</td>\n",
       "      <td>35.18</td>\n",
       "      <td>-5.33</td>\n",
       "      <td>17011.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002256</th>\n",
       "      <td>兆新股份</td>\n",
       "      <td>染料涂料</td>\n",
       "      <td>深圳</td>\n",
       "      <td>77.52</td>\n",
       "      <td>12.53</td>\n",
       "      <td>18.82</td>\n",
       "      <td>389777.69</td>\n",
       "      <td>113473.72</td>\n",
       "      <td>146706.50</td>\n",
       "      <td>2895.40</td>\n",
       "      <td>...</td>\n",
       "      <td>1.23</td>\n",
       "      <td>4.20</td>\n",
       "      <td>20080625</td>\n",
       "      <td>35647.12</td>\n",
       "      <td>0.19</td>\n",
       "      <td>30.51</td>\n",
       "      <td>28.13</td>\n",
       "      <td>32.47</td>\n",
       "      <td>18.37</td>\n",
       "      <td>87081.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603045</th>\n",
       "      <td>福达合金</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>浙江</td>\n",
       "      <td>262.71</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.98</td>\n",
       "      <td>114015.52</td>\n",
       "      <td>79346.43</td>\n",
       "      <td>24050.52</td>\n",
       "      <td>10085.88</td>\n",
       "      <td>...</td>\n",
       "      <td>6.88</td>\n",
       "      <td>8.46</td>\n",
       "      <td>20180517</td>\n",
       "      <td>27973.84</td>\n",
       "      <td>2.85</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>14.16</td>\n",
       "      <td>2.29</td>\n",
       "      <td>26189.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002892</th>\n",
       "      <td>科力尔</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>湖南</td>\n",
       "      <td>82.54</td>\n",
       "      <td>0.18</td>\n",
       "      <td>0.84</td>\n",
       "      <td>68069.61</td>\n",
       "      <td>50323.76</td>\n",
       "      <td>16159.40</td>\n",
       "      <td>35643.10</td>\n",
       "      <td>...</td>\n",
       "      <td>6.88</td>\n",
       "      <td>4.82</td>\n",
       "      <td>20170817</td>\n",
       "      <td>11959.07</td>\n",
       "      <td>1.43</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>19.34</td>\n",
       "      <td>5.99</td>\n",
       "      <td>13011.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300601</th>\n",
       "      <td>康泰生物</td>\n",
       "      <td>生物制药</td>\n",
       "      <td>深圳</td>\n",
       "      <td>68.09</td>\n",
       "      <td>2.40</td>\n",
       "      <td>6.34</td>\n",
       "      <td>279075.69</td>\n",
       "      <td>150465.47</td>\n",
       "      <td>45929.32</td>\n",
       "      <td>54027.55</td>\n",
       "      <td>...</td>\n",
       "      <td>2.03</td>\n",
       "      <td>23.20</td>\n",
       "      <td>20170207</td>\n",
       "      <td>45957.30</td>\n",
       "      <td>0.73</td>\n",
       "      <td>176.25</td>\n",
       "      <td>290.61</td>\n",
       "      <td>91.07</td>\n",
       "      <td>27.24</td>\n",
       "      <td>9072.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300464</th>\n",
       "      <td>星徽精密</td>\n",
       "      <td>机械基件</td>\n",
       "      <td>广东</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.91</td>\n",
       "      <td>2.08</td>\n",
       "      <td>102602.11</td>\n",
       "      <td>42266.92</td>\n",
       "      <td>41529.92</td>\n",
       "      <td>11156.00</td>\n",
       "      <td>...</td>\n",
       "      <td>2.41</td>\n",
       "      <td>4.59</td>\n",
       "      <td>20150610</td>\n",
       "      <td>16378.32</td>\n",
       "      <td>0.79</td>\n",
       "      <td>9.30</td>\n",
       "      <td>-281.84</td>\n",
       "      <td>1.12</td>\n",
       "      <td>-7.99</td>\n",
       "      <td>13341.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000616</th>\n",
       "      <td>海航投资</td>\n",
       "      <td>全国地产</td>\n",
       "      <td>辽宁</td>\n",
       "      <td>0.00</td>\n",
       "      <td>14.30</td>\n",
       "      <td>14.30</td>\n",
       "      <td>1018811.19</td>\n",
       "      <td>725476.19</td>\n",
       "      <td>589.92</td>\n",
       "      <td>20155.86</td>\n",
       "      <td>...</td>\n",
       "      <td>2.74</td>\n",
       "      <td>1.12</td>\n",
       "      <td>19961108</td>\n",
       "      <td>196664.92</td>\n",
       "      <td>1.38</td>\n",
       "      <td>40.77</td>\n",
       "      <td>-211.83</td>\n",
       "      <td>44.50</td>\n",
       "      <td>-363.21</td>\n",
       "      <td>99764.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300747</th>\n",
       "      <td>锐科激光</td>\n",
       "      <td>元器件</td>\n",
       "      <td>湖北</td>\n",
       "      <td>55.20</td>\n",
       "      <td>0.32</td>\n",
       "      <td>1.28</td>\n",
       "      <td>92597.42</td>\n",
       "      <td>73525.68</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>6.20</td>\n",
       "      <td>31.34</td>\n",
       "      <td>20180625</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>35.12</td>\n",
       "      <td>62859.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300750</th>\n",
       "      <td>宁德时代</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>福建</td>\n",
       "      <td>108.52</td>\n",
       "      <td>2.17</td>\n",
       "      <td>21.72</td>\n",
       "      <td>4782323.50</td>\n",
       "      <td>3065150.75</td>\n",
       "      <td>844667.38</td>\n",
       "      <td>1537444.25</td>\n",
       "      <td>...</td>\n",
       "      <td>12.86</td>\n",
       "      <td>6.42</td>\n",
       "      <td>20180611</td>\n",
       "      <td>691825.19</td>\n",
       "      <td>3.18</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>32.76</td>\n",
       "      <td>11.14</td>\n",
       "      <td>368718.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>002070</th>\n",
       "      <td>*ST众和</td>\n",
       "      <td>纺织</td>\n",
       "      <td>福建</td>\n",
       "      <td>0.00</td>\n",
       "      <td>5.67</td>\n",
       "      <td>6.35</td>\n",
       "      <td>191151.20</td>\n",
       "      <td>71101.90</td>\n",
       "      <td>39715.51</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.92</td>\n",
       "      <td>0.00</td>\n",
       "      <td>20061012</td>\n",
       "      <td>-125070.11</td>\n",
       "      <td>-1.97</td>\n",
       "      <td>-78.64</td>\n",
       "      <td>-230.74</td>\n",
       "      <td>12.14</td>\n",
       "      <td>-108.71</td>\n",
       "      <td>63822.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000950</th>\n",
       "      <td>*ST建峰</td>\n",
       "      <td>农药化肥</td>\n",
       "      <td>重庆</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3.17</td>\n",
       "      <td>17.28</td>\n",
       "      <td>1745695.75</td>\n",
       "      <td>1431556.00</td>\n",
       "      <td>50572.73</td>\n",
       "      <td>257322.77</td>\n",
       "      <td>...</td>\n",
       "      <td>3.95</td>\n",
       "      <td>0.00</td>\n",
       "      <td>19990916</td>\n",
       "      <td>247819.27</td>\n",
       "      <td>1.43</td>\n",
       "      <td>3.33</td>\n",
       "      <td>19.52</td>\n",
       "      <td>8.76</td>\n",
       "      <td>2.26</td>\n",
       "      <td>30887.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000693</th>\n",
       "      <td>*ST华泽</td>\n",
       "      <td>小金属</td>\n",
       "      <td>四川</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2.58</td>\n",
       "      <td>5.43</td>\n",
       "      <td>174616.61</td>\n",
       "      <td>119004.47</td>\n",
       "      <td>38596.90</td>\n",
       "      <td>-3052.87</td>\n",
       "      <td>...</td>\n",
       "      <td>-2.66</td>\n",
       "      <td>0.00</td>\n",
       "      <td>19970226</td>\n",
       "      <td>-210877.55</td>\n",
       "      <td>-3.88</td>\n",
       "      <td>-99.94</td>\n",
       "      <td>97.36</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-514.91</td>\n",
       "      <td>65900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>000629</th>\n",
       "      <td>*ST钒钛</td>\n",
       "      <td>小金属</td>\n",
       "      <td>四川</td>\n",
       "      <td>0.00</td>\n",
       "      <td>47.67</td>\n",
       "      <td>85.90</td>\n",
       "      <td>1035901.50</td>\n",
       "      <td>420821.66</td>\n",
       "      <td>440596.94</td>\n",
       "      <td>553947.19</td>\n",
       "      <td>...</td>\n",
       "      <td>0.56</td>\n",
       "      <td>0.00</td>\n",
       "      <td>19961115</td>\n",
       "      <td>-1080200.75</td>\n",
       "      <td>-1.26</td>\n",
       "      <td>44.83</td>\n",
       "      <td>110.61</td>\n",
       "      <td>23.58</td>\n",
       "      <td>14.68</td>\n",
       "      <td>309055.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603657</th>\n",
       "      <td>春光科技</td>\n",
       "      <td>塑料</td>\n",
       "      <td>浙江</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>47914.42</td>\n",
       "      <td>34190.25</td>\n",
       "      <td>9175.00</td>\n",
       "      <td>14718.79</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>12014.15</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>36.18</td>\n",
       "      <td>12.61</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>603192</th>\n",
       "      <td>汇得科技</td>\n",
       "      <td>化工原料</td>\n",
       "      <td>上海</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>111471.45</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6.43</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601606</th>\n",
       "      <td>长城军工</td>\n",
       "      <td>专用机械</td>\n",
       "      <td>安徽</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>301683.69</td>\n",
       "      <td>157939.27</td>\n",
       "      <td>97678.93</td>\n",
       "      <td>33321.71</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>67919.21</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>28.36</td>\n",
       "      <td>2.74</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>601068</th>\n",
       "      <td>中铝国际</td>\n",
       "      <td>建筑施工</td>\n",
       "      <td>北京</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4447294.50</td>\n",
       "      <td>3593419.25</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>7.59</td>\n",
       "      <td>0.61</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600680</th>\n",
       "      <td>*ST上普</td>\n",
       "      <td>通信设备</td>\n",
       "      <td>上海</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2.57</td>\n",
       "      <td>3.82</td>\n",
       "      <td>204606.86</td>\n",
       "      <td>46642.46</td>\n",
       "      <td>8051.46</td>\n",
       "      <td>86861.46</td>\n",
       "      <td>...</td>\n",
       "      <td>0.90</td>\n",
       "      <td>0.00</td>\n",
       "      <td>19931018</td>\n",
       "      <td>-102430.28</td>\n",
       "      <td>-2.68</td>\n",
       "      <td>-38.37</td>\n",
       "      <td>3.36</td>\n",
       "      <td>27.42</td>\n",
       "      <td>-29.07</td>\n",
       "      <td>37730.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600401</th>\n",
       "      <td>*ST海润</td>\n",
       "      <td>半导体</td>\n",
       "      <td>江苏</td>\n",
       "      <td>0.00</td>\n",
       "      <td>47.25</td>\n",
       "      <td>47.25</td>\n",
       "      <td>1299362.38</td>\n",
       "      <td>459933.81</td>\n",
       "      <td>576208.38</td>\n",
       "      <td>125456.07</td>\n",
       "      <td>...</td>\n",
       "      <td>0.21</td>\n",
       "      <td>0.00</td>\n",
       "      <td>20030924</td>\n",
       "      <td>-496537.91</td>\n",
       "      <td>-1.05</td>\n",
       "      <td>-61.50</td>\n",
       "      <td>31.13</td>\n",
       "      <td>1.45</td>\n",
       "      <td>-67.05</td>\n",
       "      <td>241924.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300724</th>\n",
       "      <td>捷佳伟创</td>\n",
       "      <td>专用机械</td>\n",
       "      <td>深圳</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>264491.25</td>\n",
       "      <td>233403.41</td>\n",
       "      <td>4162.93</td>\n",
       "      <td>17682.42</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>49275.15</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>37.41</td>\n",
       "      <td>19.69</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3538 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         name industry area      pe  outstanding  totals  totalAssets  \\\n",
       "code                                                                    \n",
       "300028    *金亚     通信设备   四川    0.00         3.44    3.44     28822.96   \n",
       "000509   华塑控股     其他建材   四川    0.00         8.25    8.25     24894.26   \n",
       "000680   山推股份     工程机械   山东   29.73        10.57   12.41   1014333.38   \n",
       "300058   蓝色光标     广告包装   北京   20.98        16.62   21.82   1712029.75   \n",
       "300129   泰胜风能     电气设备   上海   48.68         4.91    7.19    318765.88   \n",
       "002447   晨鑫科技      互联网   辽宁   18.89        11.50   14.27    278472.50   \n",
       "000955   欣龙控股       纺织   海南    0.00         5.38    5.38    130058.56   \n",
       "002786   银宝山新     专用机械   深圳    0.00         1.37    3.81    382388.88   \n",
       "300032   金龙机电      元器件   浙江    0.00         7.89    8.03    687549.38   \n",
       "600812   华北制药     化学制药   河北   84.34        16.31   16.31   1716590.25   \n",
       "000613   大东海A     旅游服务   海南  404.08         2.66    3.64      8896.94   \n",
       "600712   南宁百货       百货   广西    0.00         5.38    5.45    223470.66   \n",
       "000498   山东路桥     建筑施工   山东   42.80         4.41   11.20   1818272.63   \n",
       "000735  罗 牛 山     农业综合   海南   11.04        10.60   11.52    648092.25   \n",
       "300443   金雷风电     专用机械   山东   49.94         1.59    2.38    171590.59   \n",
       "600303   曙光股份     汽车整车   辽宁   69.31         6.20    6.76    757613.50   \n",
       "002759   天际股份     家用电器   广东  119.56         1.26    4.52    377837.97   \n",
       "300096    易联众     软件服务   福建    0.00         3.77    4.30    186299.81   \n",
       "300238   冠昊生物     医疗保健   广东  130.09         2.46    2.65    166138.77   \n",
       "601619   嘉泽新能     新型电力   宁夏   74.02         1.94   19.33    891525.38   \n",
       "002072    凯瑞德      互联网   山东    0.00         1.76    1.76     67810.21   \n",
       "300635   达安股份     建筑施工   广东   45.58         0.40    1.36     88269.88   \n",
       "002899    英派斯     文教休闲   山东  116.00         0.30    1.20    120439.52   \n",
       "603843   正平股份     建筑施工   青海   47.01         1.93    4.00    473199.75   \n",
       "600876   洛阳玻璃       玻璃   河南  551.66         2.62    5.60    301194.34   \n",
       "000760    斯太尔     汽车配件   湖北    0.00         6.54    7.72    237887.88   \n",
       "300547   川环科技       橡胶   四川   27.13         0.63    1.23     99290.40   \n",
       "300134   大富科技     通信设备   深圳   75.02         7.12    7.67    723251.50   \n",
       "603105   芯能科技     电气设备   浙江  251.20         0.88    5.00    219210.59   \n",
       "300746   汉嘉设计     建筑施工   浙江  175.50         0.53    2.10     84655.75   \n",
       "...       ...      ...  ...     ...          ...     ...          ...   \n",
       "300469   信息发展     软件服务   上海    0.00         0.97    1.22    120729.17   \n",
       "002896   中大力德     机械基件   浙江   70.25         0.20    0.80     79958.13   \n",
       "002375   亚厦股份     装修装饰   浙江   24.70        12.52   13.40   1875978.63   \n",
       "002580   圣阳股份     电气设备   山东  148.50         2.98    3.54    199927.50   \n",
       "600734   实达集团     电脑设备   福建    0.00         3.55    6.24    840366.13   \n",
       "002778   高科石化     石油加工   江苏   78.92         0.56    0.89     76581.24   \n",
       "002806   华锋股份      元器件   广东  249.71         0.56    1.37     67823.78   \n",
       "300551   古鳌科技     专用机械   上海    0.00         0.65    1.10     65781.31   \n",
       "600448   华纺股份       纺织   山东  329.86         4.22    5.25    348429.72   \n",
       "002857   三晖电气     电器仪表   河南    0.00         0.49    1.28     54155.85   \n",
       "300491   通合科技     电气设备   河北    0.00         0.51    1.45     56704.98   \n",
       "002256   兆新股份     染料涂料   深圳   77.52        12.53   18.82    389777.69   \n",
       "603045   福达合金     电气设备   浙江  262.71         0.25    0.98    114015.52   \n",
       "002892    科力尔     电气设备   湖南   82.54         0.18    0.84     68069.61   \n",
       "300601   康泰生物     生物制药   深圳   68.09         2.40    6.34    279075.69   \n",
       "300464   星徽精密     机械基件   广东    0.00         0.91    2.08    102602.11   \n",
       "000616   海航投资     全国地产   辽宁    0.00        14.30   14.30   1018811.19   \n",
       "300747   锐科激光      元器件   湖北   55.20         0.32    1.28     92597.42   \n",
       "300750   宁德时代     电气设备   福建  108.52         2.17   21.72   4782323.50   \n",
       "002070  *ST众和       纺织   福建    0.00         5.67    6.35    191151.20   \n",
       "000950  *ST建峰     农药化肥   重庆    0.00         3.17   17.28   1745695.75   \n",
       "000693  *ST华泽      小金属   四川    0.00         2.58    5.43    174616.61   \n",
       "000629  *ST钒钛      小金属   四川    0.00        47.67   85.90   1035901.50   \n",
       "603657   春光科技       塑料   浙江    0.00         0.00    0.00     47914.42   \n",
       "603192   汇得科技     化工原料   上海    0.00         0.00    0.00    111471.45   \n",
       "601606   长城军工     专用机械   安徽    0.00         0.00    0.00    301683.69   \n",
       "601068   中铝国际     建筑施工   北京    0.00         0.00    0.00   4447294.50   \n",
       "600680  *ST上普     通信设备   上海    0.00         2.57    3.82    204606.86   \n",
       "600401  *ST海润      半导体   江苏    0.00        47.25   47.25   1299362.38   \n",
       "300724   捷佳伟创     专用机械   深圳    0.00         0.00    0.00    264491.25   \n",
       "\n",
       "        liquidAssets  fixedAssets    reserved    ...      bvps     pb  \\\n",
       "code                                             ...                    \n",
       "300028       8798.60      1260.96    36319.64    ...      0.49   1.91   \n",
       "000509      18130.70      1169.06    21226.06    ...      0.05  51.74   \n",
       "000680     655271.00    170036.41   120013.10    ...      2.70   1.49   \n",
       "300058     898685.81     11862.67   266160.66    ...      2.80   2.11   \n",
       "300129     209734.02     60982.78    70538.61    ...      3.15   1.21   \n",
       "002447      77991.53     39287.96        0.00    ...      1.51   2.53   \n",
       "000955      66284.50     44417.80    49573.46    ...      1.33   4.03   \n",
       "002786     254915.72     89801.25    17355.93    ...      2.85   2.41   \n",
       "300032     399175.13    126680.40   319012.75    ...      5.00   1.03   \n",
       "600812     685183.38    771604.75   348135.28    ...      3.27   1.67   \n",
       "000613       1619.50      3843.58     5414.27    ...      0.22  40.32   \n",
       "600712      74036.81    110228.90    36985.75    ...      1.95   2.41   \n",
       "000498    1446253.50     62741.83   -55661.53    ...      3.61   1.37   \n",
       "000735     184335.61    194501.98   158896.80    ...      3.36   3.79   \n",
       "300443     106978.13     43072.73    68372.13    ...      6.87   1.63   \n",
       "600303     368062.97    250697.25   111036.77    ...      4.61   1.24   \n",
       "002759      82102.21     56931.60   261366.27    ...      7.42   1.23   \n",
       "300096     126820.07      8067.67     3240.18    ...      1.64   6.47   \n",
       "300238      40367.30     19332.30    58982.98    ...      4.39   3.35   \n",
       "601619     150262.70    614176.25    19287.90    ...      1.28   5.90   \n",
       "002072      46591.28       289.06    19168.22    ...      0.32  26.08   \n",
       "300635      69621.18      3760.75    22048.47    ...      4.49   3.74   \n",
       "002899      90348.06     18197.43    62523.36    ...      7.98   2.90   \n",
       "603843     352058.41     45174.01    37026.40    ...      3.27   2.92   \n",
       "600876     101826.80    147461.95   129728.22    ...      1.01  15.86   \n",
       "000760      81028.38     30768.28   142629.50    ...      2.32   2.42   \n",
       "300547      80726.84     14631.29    38303.71    ...      5.95   4.04   \n",
       "300134     431399.44    145129.63   484651.84    ...      6.98   1.78   \n",
       "603105      83854.71    123671.57    42923.34    ...      2.50   8.74   \n",
       "300746      62115.23     15889.55    10680.12    ...      3.87  10.19   \n",
       "...              ...          ...         ...    ...       ...    ...   \n",
       "300469      84026.68      1839.18    22466.65    ...      3.31   7.90   \n",
       "002896      46085.62     24906.48    32320.94    ...      6.81   6.54   \n",
       "002375    1593443.50     72511.11   183730.72    ...      5.65   1.08   \n",
       "002580     139065.56     42368.53    53754.13    ...      3.31   1.98   \n",
       "600734     590714.06     21819.70   209117.17    ...      4.56   1.75   \n",
       "002778      51419.80      7615.63    21435.85    ...      7.01   3.14   \n",
       "002806      35466.23     21915.98     3962.88    ...      2.85   9.64   \n",
       "300551      55414.13      8572.61    22942.30    ...      4.65   3.10   \n",
       "600448     207782.20     97555.05   114670.90    ...      2.76   1.63   \n",
       "002857      49890.67      1136.95    16406.72    ...      3.31   4.27   \n",
       "300491      37041.20     16516.35    18042.42    ...      2.96   6.16   \n",
       "002256     113473.72    146706.50     2895.40    ...      1.23   4.20   \n",
       "603045      79346.43     24050.52    10085.88    ...      6.88   8.46   \n",
       "002892      50323.76     16159.40    35643.10    ...      6.88   4.82   \n",
       "300601     150465.47     45929.32    54027.55    ...      2.03  23.20   \n",
       "300464      42266.92     41529.92    11156.00    ...      2.41   4.59   \n",
       "000616     725476.19       589.92    20155.86    ...      2.74   1.12   \n",
       "300747      73525.68         0.00        0.00    ...      6.20  31.34   \n",
       "300750    3065150.75    844667.38  1537444.25    ...     12.86   6.42   \n",
       "002070      71101.90     39715.51        0.00    ...     -0.92   0.00   \n",
       "000950    1431556.00     50572.73   257322.77    ...      3.95   0.00   \n",
       "000693     119004.47     38596.90    -3052.87    ...     -2.66   0.00   \n",
       "000629     420821.66    440596.94   553947.19    ...      0.56   0.00   \n",
       "603657      34190.25      9175.00    14718.79    ...      0.00   0.00   \n",
       "603192          0.00         0.00        0.00    ...      0.00   0.00   \n",
       "601606     157939.27     97678.93    33321.71    ...      0.00   0.00   \n",
       "601068    3593419.25         0.00        0.00    ...      0.00   0.00   \n",
       "600680      46642.46      8051.46    86861.46    ...      0.90   0.00   \n",
       "600401     459933.81    576208.38   125456.07    ...      0.21   0.00   \n",
       "300724     233403.41      4162.93    17682.42    ...      0.00   0.00   \n",
       "\n",
       "        timeToMarket        undp  perundp     rev   profit    gpr     npr  \\\n",
       "code                                                                        \n",
       "300028      20091030   -53770.92    -1.56  689.74    63.14  -4.99  -42.90   \n",
       "000509      19930507  -102324.15    -1.24  585.13    -0.01   0.55   -0.78   \n",
       "000680      19970122    53637.21     0.43   30.83   149.71  14.03    1.99   \n",
       "300058      20100226   195004.25     0.89   70.62    89.69  13.01    3.05   \n",
       "300129      20101019    80128.02     1.11   35.41   -65.04  24.50    6.08   \n",
       "002447      20100713    69922.93     0.49  191.73   559.98  73.05   46.88   \n",
       "000955      19991209   -31975.74    -0.59   18.88  -595.87  12.10   -5.93   \n",
       "002786      20151223    47619.00     1.25    7.81  -306.02  14.04   -2.61   \n",
       "300032      20091225   -11428.19    -0.14   29.32  -227.05  15.12   -2.67   \n",
       "600812      19940114     -105.19     0.00   13.94    96.02  35.74    1.07   \n",
       "000613      19970128   -33913.40    -0.93    5.39   -18.13  68.90   19.95   \n",
       "600712      19960626     9523.53     0.17   10.20    31.67  15.51   -0.02   \n",
       "000498      19970609   254251.02     2.27   52.18    20.25   8.35    1.63   \n",
       "000735      19970611   102907.93     0.89  -63.64   284.81  16.97  167.48   \n",
       "300443      20150422    63543.19     2.67  -41.59   -73.77  26.27   13.32   \n",
       "600303      20001226   105605.81     1.56   -3.49   -96.89  18.62    1.63   \n",
       "002759      20150528    25523.82     0.56  -31.15   -89.40  28.07    4.91   \n",
       "300096      20100728    21774.78     0.51   59.23    17.87  56.91  -22.66   \n",
       "300238      20110706    28590.51     1.08   -8.92    -9.45  71.04    9.46   \n",
       "601619      20170720    33416.89     0.17   27.63    71.02  55.15   21.69   \n",
       "002072      20061018   -35039.10    -1.99   90.53   -85.18  10.51  -12.29   \n",
       "300635      20170331    22471.31     1.66   18.43     9.39  33.26   11.99   \n",
       "002899      20170915    18716.98     1.56   11.45   -61.27  27.74    3.44   \n",
       "603843      20160905    43340.73     1.08  248.13   245.44   7.77    3.39   \n",
       "600876      19951031  -134282.52    -2.40  -10.95   -66.96  28.21    1.68   \n",
       "000760      19970627   -40307.01    -0.52   93.24    29.63  19.02  -43.31   \n",
       "300547      20160930    31618.75     2.56   19.44    23.13  36.38   17.79   \n",
       "300134      20101026   -36342.10    -0.47   -4.02   243.60  20.04    7.01   \n",
       "603105      20180709    16217.49     0.32    0.00     0.00  38.38   12.35   \n",
       "300746      20180525    29412.24     1.40    0.00     0.00  18.70    6.51   \n",
       "...              ...         ...      ...     ...      ...    ...     ...   \n",
       "300469      20150611    15062.50     1.23   -9.21    12.76  45.10  -41.62   \n",
       "002896      20170829    12825.95     1.60    0.00     0.00  32.17   11.40   \n",
       "002375      20100323   405948.38     3.03   16.53    11.70  13.61    4.43   \n",
       "002580      20110506    27261.44     0.77   13.38   -38.89  14.82    1.07   \n",
       "600734      19960808    11150.55     0.18  -13.89 -1950.34   7.03   -2.70   \n",
       "002778      20160106    28851.31     3.24   -3.01   -22.90  13.62    4.74   \n",
       "002806      20160726    19428.03     1.42   14.89     8.52  20.02    3.57   \n",
       "300551      20161018    18743.60     1.70   38.04    13.87  41.53  -61.74   \n",
       "600448      20010903   -22770.80    -0.43   27.87   -19.26   5.12    0.24   \n",
       "002857      20170323    15747.24     1.23  -24.90    54.82  36.68  -12.03   \n",
       "300491      20151231    10821.80     0.75  -10.47    16.74  35.18   -5.33   \n",
       "002256      20080625    35647.12     0.19   30.51    28.13  32.47   18.37   \n",
       "603045      20180517    27973.84     2.85    0.00     0.00  14.16    2.29   \n",
       "002892      20170817    11959.07     1.43    0.00     0.00  19.34    5.99   \n",
       "300601      20170207    45957.30     0.73  176.25   290.61  91.07   27.24   \n",
       "300464      20150610    16378.32     0.79    9.30  -281.84   1.12   -7.99   \n",
       "000616      19961108   196664.92     1.38   40.77  -211.83  44.50 -363.21   \n",
       "300747      20180625        0.00     0.00    0.00     0.00   0.00   35.12   \n",
       "300750      20180611   691825.19     3.18    0.00     0.00  32.76   11.14   \n",
       "002070      20061012  -125070.11    -1.97  -78.64  -230.74  12.14 -108.71   \n",
       "000950      19990916   247819.27     1.43    3.33    19.52   8.76    2.26   \n",
       "000693      19970226  -210877.55    -3.88  -99.94    97.36   0.00 -514.91   \n",
       "000629      19961115 -1080200.75    -1.26   44.83   110.61  23.58   14.68   \n",
       "603657             0    12014.15     0.00    0.00     0.00  36.18   12.61   \n",
       "603192             0        0.00     0.00    0.00     0.00   0.00    6.43   \n",
       "601606             0    67919.21     0.00    0.00     0.00  28.36    2.74   \n",
       "601068             0        0.00     0.00    0.00     0.00   7.59    0.61   \n",
       "600680      19931018  -102430.28    -2.68  -38.37     3.36  27.42  -29.07   \n",
       "600401      20030924  -496537.91    -1.05  -61.50    31.13   1.45  -67.05   \n",
       "300724             0    49275.15     0.00    0.00     0.00  37.41   19.69   \n",
       "\n",
       "         holders  \n",
       "code              \n",
       "300028   43895.0  \n",
       "000509   63186.0  \n",
       "000680  121102.0  \n",
       "300058   80183.0  \n",
       "300129   45010.0  \n",
       "002447   73862.0  \n",
       "000955   34521.0  \n",
       "002786   35296.0  \n",
       "300032   26221.0  \n",
       "600812   82855.0  \n",
       "000613   40000.0  \n",
       "600712   24310.0  \n",
       "000498   51067.0  \n",
       "000735  178400.0  \n",
       "300443   17864.0  \n",
       "600303   75427.0  \n",
       "002759   18577.0  \n",
       "300096   22871.0  \n",
       "300238   20905.0  \n",
       "601619   70322.0  \n",
       "002072    7603.0  \n",
       "300635   12309.0  \n",
       "002899   18153.0  \n",
       "603843   25696.0  \n",
       "600876   58178.0  \n",
       "000760   45460.0  \n",
       "300547   14513.0  \n",
       "300134   58325.0  \n",
       "603105   84136.0  \n",
       "300746  100201.0  \n",
       "...          ...  \n",
       "300469   15609.0  \n",
       "002896   11789.0  \n",
       "002375   40718.0  \n",
       "002580   36062.0  \n",
       "600734   40863.0  \n",
       "002778   12070.0  \n",
       "002806   16400.0  \n",
       "300551   12384.0  \n",
       "600448   29660.0  \n",
       "002857    7366.0  \n",
       "300491   17011.0  \n",
       "002256   87081.0  \n",
       "603045   26189.0  \n",
       "002892   13011.0  \n",
       "300601    9072.0  \n",
       "300464   13341.0  \n",
       "000616   99764.0  \n",
       "300747   62859.0  \n",
       "300750  368718.0  \n",
       "002070   63822.0  \n",
       "000950   30887.0  \n",
       "000693   65900.0  \n",
       "000629  309055.0  \n",
       "603657       0.0  \n",
       "603192       0.0  \n",
       "601606       0.0  \n",
       "601068       0.0  \n",
       "600680   37730.0  \n",
       "600401  241924.0  \n",
       "300724       0.0  \n",
       "\n",
       "[3538 rows x 22 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sb"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 业绩报告（主表）\n",
    "\n",
    "按年度、季度获取业绩报表数据。数据获取需要一定的时间，网速取决于您的网速，请耐心等待。结果返回的数据属性说明如下：\n",
    "```\n",
    "code,代码\n",
    "name,名称\n",
    "esp,每股收益\n",
    "eps_yoy,每股收益同比(%)\n",
    "bvps,每股净资产\n",
    "roe,净资产收益率(%)\n",
    "epcf,每股现金流量(元)\n",
    "net_profits,净利润(万元)\n",
    "profits_yoy,净利润同比(%)\n",
    "distrib,分配方案\n",
    "report_date,发布日期\n",
    "```\n",
    "\n",
    "调用方法：\n",
    "```\n",
    "#获取2014年第3季度的业绩报表数据\n",
    "ts.get_report_data(2014,3)\n",
    "```\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 盈利能力\n",
    "\n",
    "按年度、季度获取盈利能力数据，结果返回的数据属性说明如下：\n",
    "```\n",
    "code,代码\n",
    "name,名称\n",
    "roe,净资产收益率(%)\n",
    "net_profit_ratio,净利率(%)\n",
    "gross_profit_rate,毛利率(%)\n",
    "net_profits,净利润(万元)\n",
    "esp,每股收益\n",
    "business_income,营业收入(百万元)\n",
    "bips,每股主营业务收入(元)\n",
    "```\n",
    "\n",
    "调用方法：\n",
    "```\n",
    "#获取2014年第3季度的盈利能力数据\n",
    "ts.get_profit_data(2014,3)\n",
    "```"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 营运能力\n",
    "\n",
    "按年度、季度获取营运能力数据，结果返回的数据属性说明如下：\n",
    "```\n",
    "code,代码\n",
    "name,名称\n",
    "arturnover,应收账款周转率(次)\n",
    "arturndays,应收账款周转天数(天)\n",
    "inventory_turnover,存货周转率(次)\n",
    "inventory_days,存货周转天数(天)\n",
    "currentasset_turnover,流动资产周转率(次)\n",
    "currentasset_days,流动资产周转天数(天)\n",
    "```\n",
    "\n",
    "调用方法：\n",
    "```\n",
    "#获取2014年第3季度的营运能力数据\n",
    "ts.get_operation_data(2014,3)\n",
    "```"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 成长能力\n",
    "\n",
    "按年度、季度获取成长能力数据，结果返回的数据属性说明如下：\n",
    "```\n",
    "code,代码\n",
    "name,名称\n",
    "mbrg,主营业务收入增长率(%)\n",
    "nprg,净利润增长率(%)\n",
    "nav,净资产增长率\n",
    "targ,总资产增长率\n",
    "epsg,每股收益增长率\n",
    "seg,股东权益增长率\n",
    "```\n",
    "\n",
    "调用方法：\n",
    "```\n",
    "#获取2014年第3季度的成长能力数据\n",
    "ts.get_growth_data(2014,3)\n",
    "```"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 偿债能力\n",
    "\n",
    "按年度、季度获取偿债能力数据，结果返回的数据属性说明如下：\n",
    "```\n",
    "code,代码\n",
    "name,名称\n",
    "currentratio,流动比率\n",
    "quickratio,速动比率\n",
    "cashratio,现金比率\n",
    "icratio,利息支付倍数\n",
    "sheqratio,股东权益比率\n",
    "adratio,股东权益增长率\n",
    "```\n",
    "\n",
    "调用方法：\n",
    "```\n",
    "#获取2014年第3季度的偿债能力数据\n",
    "ts.get_debtpaying_data(2014,3)\n",
    "```"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 现金流量\n",
    "\n",
    "按年度、季度获取现金流量数据，结果返回的数据属性说明如下：\n",
    "```\n",
    "code,代码\n",
    "name,名称\n",
    "cf_sales,经营现金净流量对销售收入比率\n",
    "rateofreturn,资产的经营现金流量回报率\n",
    "cf_nm,经营现金净流量与净利润的比率\n",
    "cf_liabilities,经营现金净流量对负债比率\n",
    "cashflowratio,现金流量比率\n",
    "```\n",
    "\n",
    "调用方法：\n",
    "\n",
    "```\n",
    "#获取2014年第3季度的现金流量数据\n",
    "ts.get_cashflow_data(2014,3)\n",
    "```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[Getting data:]###########################################################"
     ]
    }
   ],
   "source": [
    "import tushare as ts\n",
    "\n",
    "cf2018 = ts.get_cashflow_data(2018,1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>cf_sales</th>\n",
       "      <th>rateofreturn</th>\n",
       "      <th>cf_nm</th>\n",
       "      <th>cf_liabilities</th>\n",
       "      <th>cashflowratio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>002670</td>\n",
       "      <td>国盛金控</td>\n",
       "      <td>4038.9027</td>\n",
       "      <td>0.0465</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0815</td>\n",
       "      <td>12.7285</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>000627</td>\n",
       "      <td>天茂集团</td>\n",
       "      <td>106.7493</td>\n",
       "      <td>0.0912</td>\n",
       "      <td>22.8118</td>\n",
       "      <td>0.1087</td>\n",
       "      <td>82.3892</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>600247</td>\n",
       "      <td>*ST成城</td>\n",
       "      <td>25.9827</td>\n",
       "      <td>0.5329</td>\n",
       "      <td>19.0240</td>\n",
       "      <td>0.5558</td>\n",
       "      <td>67.5694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>600155</td>\n",
       "      <td>华创阳安</td>\n",
       "      <td>10.8318</td>\n",
       "      <td>0.0124</td>\n",
       "      <td>6.8863</td>\n",
       "      <td>0.0210</td>\n",
       "      <td>2.6094</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>000046</td>\n",
       "      <td>泛海控股</td>\n",
       "      <td>10.4512</td>\n",
       "      <td>0.0171</td>\n",
       "      <td>2.1756</td>\n",
       "      <td>0.0200</td>\n",
       "      <td>3.3597</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>300059</td>\n",
       "      <td>东方财富</td>\n",
       "      <td>6.6292</td>\n",
       "      <td>0.0539</td>\n",
       "      <td>8.0911</td>\n",
       "      <td>0.0807</td>\n",
       "      <td>9.8654</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>000809</td>\n",
       "      <td>铁岭新城</td>\n",
       "      <td>5.7562</td>\n",
       "      <td>0.0057</td>\n",
       "      <td>1.1204</td>\n",
       "      <td>0.0120</td>\n",
       "      <td>2.6375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>000517</td>\n",
       "      <td>荣安地产</td>\n",
       "      <td>5.5351</td>\n",
       "      <td>0.0323</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0437</td>\n",
       "      <td>5.9904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>600053</td>\n",
       "      <td>九鼎投资</td>\n",
       "      <td>4.2222</td>\n",
       "      <td>0.1390</td>\n",
       "      <td>14.7679</td>\n",
       "      <td>0.2358</td>\n",
       "      <td>27.7345</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>300189</td>\n",
       "      <td>神农基因</td>\n",
       "      <td>3.7140</td>\n",
       "      <td>0.0992</td>\n",
       "      <td>17.5345</td>\n",
       "      <td>0.5996</td>\n",
       "      <td>71.5925</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>600598</td>\n",
       "      <td>北大荒</td>\n",
       "      <td>3.7008</td>\n",
       "      <td>0.2489</td>\n",
       "      <td>8.8613</td>\n",
       "      <td>0.6259</td>\n",
       "      <td>64.1505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>000576</td>\n",
       "      <td>广东甘化</td>\n",
       "      <td>3.7001</td>\n",
       "      <td>0.2652</td>\n",
       "      <td>192.2317</td>\n",
       "      <td>5.8228</td>\n",
       "      <td>583.8132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>300483</td>\n",
       "      <td>沃施股份</td>\n",
       "      <td>2.3764</td>\n",
       "      <td>0.1320</td>\n",
       "      <td>18.4229</td>\n",
       "      <td>0.1816</td>\n",
       "      <td>18.1564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>300023</td>\n",
       "      <td>宝德股份</td>\n",
       "      <td>2.1721</td>\n",
       "      <td>0.0444</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0541</td>\n",
       "      <td>6.6040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>000567</td>\n",
       "      <td>海德股份</td>\n",
       "      <td>2.0231</td>\n",
       "      <td>0.0235</td>\n",
       "      <td>7.3780</td>\n",
       "      <td>0.0534</td>\n",
       "      <td>6.9755</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>600225</td>\n",
       "      <td>天津松江</td>\n",
       "      <td>1.8876</td>\n",
       "      <td>0.0097</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0110</td>\n",
       "      <td>1.5682</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>603377</td>\n",
       "      <td>东方时尚</td>\n",
       "      <td>1.7574</td>\n",
       "      <td>0.1010</td>\n",
       "      <td>53.9148</td>\n",
       "      <td>0.2554</td>\n",
       "      <td>31.2865</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>600318</td>\n",
       "      <td>新力金融</td>\n",
       "      <td>1.6845</td>\n",
       "      <td>0.0374</td>\n",
       "      <td>5.0635</td>\n",
       "      <td>0.0574</td>\n",
       "      <td>9.3274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>002039</td>\n",
       "      <td>黔源电力</td>\n",
       "      <td>1.5530</td>\n",
       "      <td>0.0354</td>\n",
       "      <td>12.7948</td>\n",
       "      <td>0.0482</td>\n",
       "      <td>27.2398</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>300295</td>\n",
       "      <td>三六五网</td>\n",
       "      <td>1.4673</td>\n",
       "      <td>0.0926</td>\n",
       "      <td>7.1715</td>\n",
       "      <td>0.3468</td>\n",
       "      <td>34.6836</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>000791</td>\n",
       "      <td>甘肃电投</td>\n",
       "      <td>1.4649</td>\n",
       "      <td>0.0228</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0329</td>\n",
       "      <td>28.1933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>002167</td>\n",
       "      <td>东方锆业</td>\n",
       "      <td>1.4507</td>\n",
       "      <td>0.0773</td>\n",
       "      <td>17.4503</td>\n",
       "      <td>0.1243</td>\n",
       "      <td>18.3420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>000029</td>\n",
       "      <td>深深房A</td>\n",
       "      <td>1.3732</td>\n",
       "      <td>0.0492</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.1391</td>\n",
       "      <td>14.1904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>600515</td>\n",
       "      <td>海航基础</td>\n",
       "      <td>1.3544</td>\n",
       "      <td>0.0188</td>\n",
       "      <td>2.7447</td>\n",
       "      <td>0.0349</td>\n",
       "      <td>4.9527</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>002095</td>\n",
       "      <td>生意宝</td>\n",
       "      <td>1.3118</td>\n",
       "      <td>0.0710</td>\n",
       "      <td>7.3763</td>\n",
       "      <td>0.3129</td>\n",
       "      <td>31.5460</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>000056</td>\n",
       "      <td>皇庭国际</td>\n",
       "      <td>1.3047</td>\n",
       "      <td>0.0204</td>\n",
       "      <td>4.4599</td>\n",
       "      <td>0.0347</td>\n",
       "      <td>14.4066</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>600846</td>\n",
       "      <td>同济科技</td>\n",
       "      <td>1.2913</td>\n",
       "      <td>0.1332</td>\n",
       "      <td>15.3426</td>\n",
       "      <td>0.1859</td>\n",
       "      <td>25.9695</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>000886</td>\n",
       "      <td>海南高速</td>\n",
       "      <td>1.2401</td>\n",
       "      <td>0.0438</td>\n",
       "      <td>4.1801</td>\n",
       "      <td>0.2449</td>\n",
       "      <td>27.0435</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>300216</td>\n",
       "      <td>千山药机</td>\n",
       "      <td>1.2091</td>\n",
       "      <td>0.0192</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0226</td>\n",
       "      <td>2.6959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>600784</td>\n",
       "      <td>鲁银投资</td>\n",
       "      <td>1.2016</td>\n",
       "      <td>0.1133</td>\n",
       "      <td>5.5604</td>\n",
       "      <td>0.1912</td>\n",
       "      <td>19.5705</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3496</th>\n",
       "      <td>600958</td>\n",
       "      <td>东方证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0348</td>\n",
       "      <td>-17.2945</td>\n",
       "      <td>-0.0455</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3497</th>\n",
       "      <td>601099</td>\n",
       "      <td>太平洋</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0038</td>\n",
       "      <td>-30.5329</td>\n",
       "      <td>-0.0050</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3498</th>\n",
       "      <td>601328</td>\n",
       "      <td>交通银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0015</td>\n",
       "      <td>0.6880</td>\n",
       "      <td>0.0016</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3499</th>\n",
       "      <td>002673</td>\n",
       "      <td>西部证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0167</td>\n",
       "      <td>5.3857</td>\n",
       "      <td>0.0251</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3500</th>\n",
       "      <td>000166</td>\n",
       "      <td>申万宏源</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0126</td>\n",
       "      <td>4.0251</td>\n",
       "      <td>0.0160</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3501</th>\n",
       "      <td>600901</td>\n",
       "      <td>江苏租赁</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0824</td>\n",
       "      <td>-13.6693</td>\n",
       "      <td>-0.1022</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3502</th>\n",
       "      <td>600999</td>\n",
       "      <td>招商证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0530</td>\n",
       "      <td>14.2344</td>\n",
       "      <td>0.0732</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3503</th>\n",
       "      <td>600015</td>\n",
       "      <td>华夏银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0241</td>\n",
       "      <td>-13.3928</td>\n",
       "      <td>-0.0259</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3504</th>\n",
       "      <td>601108</td>\n",
       "      <td>财通证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0595</td>\n",
       "      <td>9.5907</td>\n",
       "      <td>0.0932</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3505</th>\n",
       "      <td>601128</td>\n",
       "      <td>常熟银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0424</td>\n",
       "      <td>16.1000</td>\n",
       "      <td>0.0461</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3506</th>\n",
       "      <td>601398</td>\n",
       "      <td>工商银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0023</td>\n",
       "      <td>0.7861</td>\n",
       "      <td>0.0026</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3507</th>\n",
       "      <td>000776</td>\n",
       "      <td>广发证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0466</td>\n",
       "      <td>11.6992</td>\n",
       "      <td>0.0607</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3508</th>\n",
       "      <td>601838</td>\n",
       "      <td>成都银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0546</td>\n",
       "      <td>-24.0738</td>\n",
       "      <td>-0.0583</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3509</th>\n",
       "      <td>601939</td>\n",
       "      <td>建设银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0152</td>\n",
       "      <td>4.7029</td>\n",
       "      <td>0.0166</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3510</th>\n",
       "      <td>002807</td>\n",
       "      <td>江阴银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0022</td>\n",
       "      <td>1.3281</td>\n",
       "      <td>0.0024</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3511</th>\n",
       "      <td>600919</td>\n",
       "      <td>江苏银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0109</td>\n",
       "      <td>-5.8721</td>\n",
       "      <td>-0.0116</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3512</th>\n",
       "      <td>000686</td>\n",
       "      <td>东北证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0086</td>\n",
       "      <td>3.8318</td>\n",
       "      <td>0.0118</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3513</th>\n",
       "      <td>601377</td>\n",
       "      <td>兴业证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0210</td>\n",
       "      <td>6.4133</td>\n",
       "      <td>0.0269</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3514</th>\n",
       "      <td>601555</td>\n",
       "      <td>东吴证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0386</td>\n",
       "      <td>58.9889</td>\n",
       "      <td>0.0493</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3515</th>\n",
       "      <td>601628</td>\n",
       "      <td>中国人寿</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0076</td>\n",
       "      <td>1.6679</td>\n",
       "      <td>0.0086</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3516</th>\n",
       "      <td>601688</td>\n",
       "      <td>华泰证券</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0006</td>\n",
       "      <td>-0.1300</td>\n",
       "      <td>-0.0008</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3517</th>\n",
       "      <td>600145</td>\n",
       "      <td>*ST新亿</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0008</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0029</td>\n",
       "      <td>-0.6455</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3518</th>\n",
       "      <td>600291</td>\n",
       "      <td>西水股份</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.4775</td>\n",
       "      <td>-201.1644</td>\n",
       "      <td>-0.5889</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3519</th>\n",
       "      <td>600816</td>\n",
       "      <td>安信信托</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0271</td>\n",
       "      <td>-0.6760</td>\n",
       "      <td>-0.0624</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3520</th>\n",
       "      <td>000563</td>\n",
       "      <td>陕国投A</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0406</td>\n",
       "      <td>3.1300</td>\n",
       "      <td>0.2737</td>\n",
       "      <td>27.5508</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3521</th>\n",
       "      <td>600908</td>\n",
       "      <td>无锡银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0261</td>\n",
       "      <td>-13.7774</td>\n",
       "      <td>-0.0282</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3522</th>\n",
       "      <td>002142</td>\n",
       "      <td>宁波银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0007</td>\n",
       "      <td>0.2694</td>\n",
       "      <td>0.0008</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3523</th>\n",
       "      <td>600036</td>\n",
       "      <td>招商银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0086</td>\n",
       "      <td>-2.3626</td>\n",
       "      <td>-0.0093</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3524</th>\n",
       "      <td>601211</td>\n",
       "      <td>国泰君安</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0727</td>\n",
       "      <td>13.4803</td>\n",
       "      <td>0.1040</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3525</th>\n",
       "      <td>601229</td>\n",
       "      <td>上海银行</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-0.0450</td>\n",
       "      <td>-18.7437</td>\n",
       "      <td>-0.0490</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3526 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        code   name   cf_sales  rateofreturn     cf_nm  cf_liabilities  \\\n",
       "0     002670   国盛金控  4038.9027        0.0465       NaN          0.0815   \n",
       "1     000627   天茂集团   106.7493        0.0912   22.8118          0.1087   \n",
       "2     600247  *ST成城    25.9827        0.5329   19.0240          0.5558   \n",
       "3     600155   华创阳安    10.8318        0.0124    6.8863          0.0210   \n",
       "4     000046   泛海控股    10.4512        0.0171    2.1756          0.0200   \n",
       "5     300059   东方财富     6.6292        0.0539    8.0911          0.0807   \n",
       "6     000809   铁岭新城     5.7562        0.0057    1.1204          0.0120   \n",
       "7     000517   荣安地产     5.5351        0.0323       NaN          0.0437   \n",
       "8     600053   九鼎投资     4.2222        0.1390   14.7679          0.2358   \n",
       "9     300189   神农基因     3.7140        0.0992   17.5345          0.5996   \n",
       "10    600598    北大荒     3.7008        0.2489    8.8613          0.6259   \n",
       "11    000576   广东甘化     3.7001        0.2652  192.2317          5.8228   \n",
       "12    300483   沃施股份     2.3764        0.1320   18.4229          0.1816   \n",
       "13    300023   宝德股份     2.1721        0.0444       NaN          0.0541   \n",
       "14    000567   海德股份     2.0231        0.0235    7.3780          0.0534   \n",
       "15    600225   天津松江     1.8876        0.0097       NaN          0.0110   \n",
       "16    603377   东方时尚     1.7574        0.1010   53.9148          0.2554   \n",
       "17    600318   新力金融     1.6845        0.0374    5.0635          0.0574   \n",
       "18    002039   黔源电力     1.5530        0.0354   12.7948          0.0482   \n",
       "19    300295   三六五网     1.4673        0.0926    7.1715          0.3468   \n",
       "20    000791   甘肃电投     1.4649        0.0228       NaN          0.0329   \n",
       "21    002167   东方锆业     1.4507        0.0773   17.4503          0.1243   \n",
       "22    000029   深深房A     1.3732        0.0492       NaN          0.1391   \n",
       "23    600515   海航基础     1.3544        0.0188    2.7447          0.0349   \n",
       "24    002095    生意宝     1.3118        0.0710    7.3763          0.3129   \n",
       "25    000056   皇庭国际     1.3047        0.0204    4.4599          0.0347   \n",
       "26    600846   同济科技     1.2913        0.1332   15.3426          0.1859   \n",
       "27    000886   海南高速     1.2401        0.0438    4.1801          0.2449   \n",
       "28    300216   千山药机     1.2091        0.0192       NaN          0.0226   \n",
       "29    600784   鲁银投资     1.2016        0.1133    5.5604          0.1912   \n",
       "...      ...    ...        ...           ...       ...             ...   \n",
       "3496  600958   东方证券        NaN       -0.0348  -17.2945         -0.0455   \n",
       "3497  601099    太平洋        NaN       -0.0038  -30.5329         -0.0050   \n",
       "3498  601328   交通银行        NaN        0.0015    0.6880          0.0016   \n",
       "3499  002673   西部证券        NaN        0.0167    5.3857          0.0251   \n",
       "3500  000166   申万宏源        NaN        0.0126    4.0251          0.0160   \n",
       "3501  600901   江苏租赁        NaN       -0.0824  -13.6693         -0.1022   \n",
       "3502  600999   招商证券        NaN        0.0530   14.2344          0.0732   \n",
       "3503  600015   华夏银行        NaN       -0.0241  -13.3928         -0.0259   \n",
       "3504  601108   财通证券        NaN        0.0595    9.5907          0.0932   \n",
       "3505  601128   常熟银行        NaN        0.0424   16.1000          0.0461   \n",
       "3506  601398   工商银行        NaN        0.0023    0.7861          0.0026   \n",
       "3507  000776   广发证券        NaN        0.0466   11.6992          0.0607   \n",
       "3508  601838   成都银行        NaN       -0.0546  -24.0738         -0.0583   \n",
       "3509  601939   建设银行        NaN        0.0152    4.7029          0.0166   \n",
       "3510  002807   江阴银行        NaN        0.0022    1.3281          0.0024   \n",
       "3511  600919   江苏银行        NaN       -0.0109   -5.8721         -0.0116   \n",
       "3512  000686   东北证券        NaN        0.0086    3.8318          0.0118   \n",
       "3513  601377   兴业证券        NaN        0.0210    6.4133          0.0269   \n",
       "3514  601555   东吴证券        NaN        0.0386   58.9889          0.0493   \n",
       "3515  601628   中国人寿        NaN        0.0076    1.6679          0.0086   \n",
       "3516  601688   华泰证券        NaN       -0.0006   -0.1300         -0.0008   \n",
       "3517  600145  *ST新亿        NaN       -0.0008       NaN         -0.0029   \n",
       "3518  600291   西水股份        NaN       -0.4775 -201.1644         -0.5889   \n",
       "3519  600816   安信信托        NaN       -0.0271   -0.6760         -0.0624   \n",
       "3520  000563   陕国投A        NaN        0.0406    3.1300          0.2737   \n",
       "3521  600908   无锡银行        NaN       -0.0261  -13.7774         -0.0282   \n",
       "3522  002142   宁波银行        NaN        0.0007    0.2694          0.0008   \n",
       "3523  600036   招商银行        NaN       -0.0086   -2.3626         -0.0093   \n",
       "3524  601211   国泰君安        NaN        0.0727   13.4803          0.1040   \n",
       "3525  601229   上海银行        NaN       -0.0450  -18.7437         -0.0490   \n",
       "\n",
       "      cashflowratio  \n",
       "0           12.7285  \n",
       "1           82.3892  \n",
       "2           67.5694  \n",
       "3            2.6094  \n",
       "4            3.3597  \n",
       "5            9.8654  \n",
       "6            2.6375  \n",
       "7            5.9904  \n",
       "8           27.7345  \n",
       "9           71.5925  \n",
       "10          64.1505  \n",
       "11         583.8132  \n",
       "12          18.1564  \n",
       "13           6.6040  \n",
       "14           6.9755  \n",
       "15           1.5682  \n",
       "16          31.2865  \n",
       "17           9.3274  \n",
       "18          27.2398  \n",
       "19          34.6836  \n",
       "20          28.1933  \n",
       "21          18.3420  \n",
       "22          14.1904  \n",
       "23           4.9527  \n",
       "24          31.5460  \n",
       "25          14.4066  \n",
       "26          25.9695  \n",
       "27          27.0435  \n",
       "28           2.6959  \n",
       "29          19.5705  \n",
       "...             ...  \n",
       "3496            NaN  \n",
       "3497            NaN  \n",
       "3498            NaN  \n",
       "3499            NaN  \n",
       "3500            NaN  \n",
       "3501            NaN  \n",
       "3502            NaN  \n",
       "3503            NaN  \n",
       "3504            NaN  \n",
       "3505            NaN  \n",
       "3506            NaN  \n",
       "3507            NaN  \n",
       "3508            NaN  \n",
       "3509            NaN  \n",
       "3510            NaN  \n",
       "3511            NaN  \n",
       "3512            NaN  \n",
       "3513            NaN  \n",
       "3514            NaN  \n",
       "3515            NaN  \n",
       "3516            NaN  \n",
       "3517        -0.6455  \n",
       "3518            NaN  \n",
       "3519            NaN  \n",
       "3520        27.5508  \n",
       "3521            NaN  \n",
       "3522            NaN  \n",
       "3523            NaN  \n",
       "3524            NaN  \n",
       "3525            NaN  \n",
       "\n",
       "[3526 rows x 7 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cf2018"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>cf_sales</th>\n",
       "      <th>rateofreturn</th>\n",
       "      <th>cf_nm</th>\n",
       "      <th>cf_liabilities</th>\n",
       "      <th>cashflowratio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3299</th>\n",
       "      <td>300036</td>\n",
       "      <td>超图软件</td>\n",
       "      <td>-1.043</td>\n",
       "      <td>-0.0978</td>\n",
       "      <td>-20.6666</td>\n",
       "      <td>-0.3553</td>\n",
       "      <td>-47.1596</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        code  name  cf_sales  rateofreturn    cf_nm  cf_liabilities  \\\n",
       "3299  300036  超图软件    -1.043       -0.0978 -20.6666         -0.3553   \n",
       "\n",
       "      cashflowratio  \n",
       "3299       -47.1596  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cf2018[cf2018.code==\"300036\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[Getting data:]###########################################################"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>cf_sales</th>\n",
       "      <th>rateofreturn</th>\n",
       "      <th>cf_nm</th>\n",
       "      <th>cf_liabilities</th>\n",
       "      <th>cashflowratio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>641</th>\n",
       "      <td>300036</td>\n",
       "      <td>超图软件</td>\n",
       "      <td>0.1995</td>\n",
       "      <td>0.0948</td>\n",
       "      <td>1.3184</td>\n",
       "      <td>0.3062</td>\n",
       "      <td>38.6757</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       code  name  cf_sales  rateofreturn   cf_nm  cf_liabilities  \\\n",
       "641  300036  超图软件    0.1995        0.0948  1.3184          0.3062   \n",
       "\n",
       "     cashflowratio  \n",
       "641        38.6757  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cf201704 = ts.get_cashflow_data(2017,4)\n",
    "cf201704[cf201704.code==\"300036\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
